{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","Assessment","Information","Lists","Results Check","Import"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":42,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,4,7,8],[30,5,30,8],[28,5,28,8],[24,5,24,8],[22,5,22,8],[23,5,23,8],[26,5,26,8],[27,5,27,8],[25,5,25,8]]}
[]
[null,"Thank you for giving this pre-workshop assessment a shot!"]
[]
[null,"Why? To make sure that YOU attend the most relevant workshop."]
[]
[null,"How? 5 simple steps…"]
[]
[null,null,null,null,"Click here if you are having any issues."]
[]
[null,null,null,null,"Save this Excel file in a folder on your C: Drive (not directly on your desktop). Hint: hit F12 to Save As."]
[]
[null,null,null,null,"Click Enable Content at the top of your screen to enable macros."]
[]
[null,null,null,null,"Insert your details below, and then click Begin."]
[]
[null,null,null,null,"Complete as much of the assessment as possible within the 5 minute time limit. Your time starts once you press Begin."]
[]
[null,null,null,null,"When you are finished, click Save Results and your answers will be saved and sent to Excel Academy."]
[]
[]
[null,"Your details:"]
[]
[null,"First Name"]
[null,"Last Name"]
[null,"Email Address"]
[null,"Country"]
[null,"Organization"]
[null,"Job Title"]
[null,"Mobile Number"]
[]
[null,null,null,null,null,"Breathe. Relax. Do your best! :)"]

{"sheet":"Assessment","index":1,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Question 1"]
[null,"In Figure 1, which item is the Formula Bar?",null,null,null,null,null,null,null,"Figure 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Question 2 refers to Figure 2"]
[null,null,null,null,null,null,null,null,null,"Figure 2"]
[null,"Question 2"]
[null,"Insert a formula in cell L24 which calculates the cost per item.",null,null,null,null,null,null,null,null,"Total Cost",12500]
[null,null,null,null,null,null,null,null,null,null,"Number of Items",125]
[null,null,null,null,null,null,null,null,null,null,"Cost per Item"]
[]
[]
[null,"Your 5 minutes is up! Please click Save Results to save and submit your Assessment."]
[]
["Questions 3 to 6 refer to Figure 3"]
[]
[null,"Question 3",null,null,null,null,null,null,null,"Figure 3"]
[null,"Insert a function in cell L39 which tallies up the cost of each item."]
[null,"Question 4",null,null,null,null,null,null,null,null,"Item","Before Discount","After Discount"]
[null,"Format cells L34:M39 in Accounting format with $ signs and 2 decimal places.",null,null,null,null,null,null,null,null,"Bread",1.29,null,null,"Discount",0.1]
[null,null,null,null,null,null,null,null,null,null,"Milk",1.49]
[null,"Question 5",null,null,null,null,null,null,null,null,"Eggs",0.79]
[null,"In cell M34, use a formula referring to P34 to calculate the \"After Discount Price\"",null,null,null,null,null,null,null,null,"Cheese",2.6]
[null,"of bread. Copy the formula down to M38. Tally up the total discounted price.",null,null,null,null,null,null,null,null,"Bananas",1.2]
[null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Question 6"]
[null,"Format cell M33 exactly like cell L33."]
[]
[]
["Questions 7 to 10 refer to Figure 4"]
[null,null,null,null,null,null,null,null,null,"Figure 4"]
[null,"Question 7"]
[null,"Sort the data alphabetically, using Excel's Sort feature, by:",null,null,null,null,null,null,null,"No","Surname","Initials","Gender","Date Started","Salary"]
[null,"a. surname",null,null,null,null,null,null,null,1,"Josephs","S","Female","2009-06-15",2100]
[null,"b. surname and then initial (so that B Naidoo is before P Naidoo)",null,null,null,null,null,null,null,2,"Naidoo","P","Female","2012-09-01",1750]
[null,null,null,null,null,null,null,null,null,3,"Martin","M","Male","2009-03-01",1400]
[null,"Question 8",null,null,null,null,null,null,null,4,"Naidoo","B","Male","2014-01-01",1250]
[null,"Make use of Conditional Formatting to highlight in red fill",null,null,null,null,null,null,null,5,"Adams","L","Male","2013-11-01",1500]
[null,"all the salaries of $1,500 or more."]
[]
[null,"Question 9",null,null,null,null,null,null,null,null,null,null,"Salary lookup:","Martin"]
[null,"a. Unprotect this sheet using the password excelacademy."]
[null,"b. Insert a dropdown list in cell M53 with the options of Male and Female."]
[null,"c. Protect the sheet using the same password."]
[]
[null,"Question 10"]
[null,"In cell O55, insert a function to lookup Mr Martin's salary."]
[]
[null,"Your 5 minutes is up! Please click Save Results to save and submit your Assessment."]
[]
[]
[null,"When you are finished, click here "]

{"sheet":"Information","index":2,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,"User's Details",null,"Time_Now",{"$f":"NOW()","v":"2022-12-10T06:52:43.440"}]
["Name",{"$f":"IF(First_Name=\"\",\"\",First_Name)","v":""},null,"Time_Start"]
["Last Name",{"$f":"IF(Surname=\"\",\"\",Surname)","v":""},null,"Time_End",{"$f":"IF(Time_Start=\"\",99999,Time_Start+TIME(0,5,0))","v":"2173-10-13"}]
["Email",{"$f":"IF(Email_Address=\"\",\"\",Email_Address)","v":""}]
["Country",{"$f":"IF(Country=\"\",\"\",Country)","v":""},null,null,null,"Your rating","Recommendation for First Workshop","Sentence"]
["Organization",{"$f":"IF(Organization=\"\",\"\",Organization)","v":""},null,null,0,"Excel Virgin","Excel 101",{"$f":"G6&\" - please click here for a message from us explaining this recommendation and the next steps: https://www.excelacademyinc.com/next2\"","v":"Excel 101 - please click here for a message from us explaining this recommendation and the next steps: https://www.excelacademyinc.com/next2"}]
["Job Title",{"$f":"IF(Job_Title=\"\",\"\",Job_Title)","v":""},null,null,0.6,"Potential Excel All Star","It depends",{"$f":"G7&\" - please click here for a message from us explaining your options and the next steps: https://www.excelacademyinc.com/next1\"","v":"It depends - please click here for a message from us explaining your options and the next steps: https://www.excelacademyinc.com/next1"}]
["Cell Number",{"$f":"IF(Cell_Number=\"\",\"\",Cell_Number)","v":""}]
[]
[null,"Countblanks"]
[null,{"$f":"COUNTBLANK(B2:B8)","v":7}]
[]
[null,"Check"]
[null,{"$f":"IF(B11>0,\"Info Missing\",\"Complete\")","v":"Info Missing"}]
[]
[null,"Today's Date",{"$f":"TODAY()","v":"2022-12-10"}]
[null,"This Workbook File Path",{"$f":"CELL(\"filename\")","v":{"$error":"#N/A"}}]
[null,"Workbook Location",{"$f":"LEFT(This_Workbook_File_Path,FIND(\"[\",This_Workbook_File_Path,1)-1)","v":{"$error":"#N/A"}}]
[null,"This Workbook Short Name",{"$f":"MID(This_Workbook_File_Path,FIND(\"[\",This_Workbook_File_Path)+1,FIND(\".xl\",This_Workbook_File_Path)-FIND(\"[\",This_Workbook_File_Path)-1)","v":{"$error":"#N/A"}}]
[null,"New Short Name",{"$f":"This_Workbook_Short_Name&\" - \"&First_Name&\" \"&Surname&\" \"&TEXT(Today_s_Date,\"yyyy-mm-dd\")&\".xlsm\"","v":{"$error":"#N/A"}}]
[null,"New File Path",{"$f":"Workbook_Location&New_Short_Name","v":{"$error":"#N/A"}}]
[]
[null,"Email Results"]
[null,"Email To",{"$f":"Email_Address","v":0}]
[null,"Email Cc","assessment@excelacademy.co.za; info@skillfully.co.za"]
[null,"Email BCc"]
[null,"Email Subject",{"$f":"New_Short_Name","v":{"$error":"#N/A"}}]
[null,"Email Body",{"$f":"\"Dear \"&First_Name&\",\n\nThanks for completing the assessment!\n\nYou will see that your completed assessment file is attached to this mail.\"&CHAR(10)&CHAR(10)&\n\nPercentage_Achieved_Sentence&CHAR(10)&\nWorkshop_Recommendation_Sentence&CHAR(10)&CHAR(10)&\n\n\"Your details:\"&CHAR(10)\n&First_Name&\" \"&Surname&CHAR(10)\n&Country&CHAR(10)\n&Organization&\" - \"&Job_Title&CHAR(10)\n&\"Email: \"&Email_Address&CHAR(10)\n&\"Mobile: \"&TEXT(Cell_Number,\"0##########\")&CHAR(10)&CHAR(10)","v":"Dear ,\n\nThanks for completing the assessment!\n\nYou will see that your completed assessment file is attached to this mail.\n\nYour result: 0.00%\nWorkshop recommendation: Excel 101 - please click here for a message from us explaining this recommendation and the next steps: https://www.excelacademyinc.com/next2\n\nYour details:\n \n\n - \nEmail: \nMobile: 0\n\n"}]
[null,"Email Attachment",{"$f":"New_File_Path","v":{"$error":"#N/A"}}]
[]
[null,"Percentage Achieved Sentence",{"$f":"\"Your result: \"&TEXT(Percentage_achieved,\"0.00%\")","v":"Your result: 0.00%"}]
[null,"Your Rating",{"$f":"VLOOKUP(Percentage_achieved,Rating_Lookup,2,TRUE)","v":"Excel Virgin"}]
[null,"Your Rating Sentence",{"$f":"\"Your rating: \"&TEXT(Your_Rating,\"0.0%\")","v":"Your rating: Excel Virgin"}]
[null,"Workshop Recommendation",{"$f":"VLOOKUP(Percentage_achieved,Rating_Lookup,3,TRUE)","v":"Excel 101"}]
[null,"Workshop Recommendation Sentence",{"$f":"\"Workshop recommendation: \"&VLOOKUP(Percentage_achieved,Rating_Lookup,4,TRUE)","v":"Workshop recommendation: Excel 101 - please click here for a message from us explaining this recommendation and the next steps: https://www.excelacademyinc.com/next2"}]
[]
[null,"Email Start"]
[null,"EmailStart To","dan@excelacademy.co.za"]
[null,"EmailStart Cc"]
[null,"EmailStart BCc"]
[null,"EmailStart Subject",{"$f":"\"Assessment Registration - \"&Organization&\" - \"&First_Name&\" \"&Surname","v":"Assessment Registration -  -  "}]
[null,"EmailStart Body",{"$f":"\"Hi Dan\n\nI have just begun my assessment.\"&CHAR(10)&CHAR(10)\n\n&First_Name&\" \"&Surname&CHAR(10)\n&Organization&\" - \"&Job_Title&CHAR(10)\n&\"Email: \"&Email_Address&CHAR(10)\n&\"Mobile: \"&TEXT(Cell_Number,\"0##########\")&CHAR(10)&CHAR(10)&\n\n\"Regards\"&CHAR(10)\n&First_Name&\" \"&Surname","v":"Hi Dan\n\nI have just begun my assessment.\n\n \n - \nEmail: \nMobile: 0\n\nRegards\n "}]
[null,"EmailStart Attachment"]
[]
[null,"Save Button Click Flag"]

{"sheet":"Lists","index":3,"n_rows":200,"n_cols":1,"rows_kept":200,"cut":false,"hidden":true,"merged":[]}
["List of Countries"]
["South Africa"]
["Mauritius"]
["Afghanistan"]
["Albania"]
["Algeria"]
["Andorra"]
["Angola"]
["Antigua and Barbuda"]
["Argentina"]
["Armenia"]
["Australia"]
["Austria"]
["Azerbaijan"]
["Bahamas"]
["Bahrain"]
["Bangladesh"]
["Barbados"]
["Belarus"]
["Belgium"]
["Belize"]
["Benin"]
["Bhutan"]
["Bolivia"]
["Bosnia and Herzegovina"]
["Botswana"]
["Brazil"]
["Brunei"]
["Bulgaria"]
["Burkina Faso"]
["Burundi"]
["Cabo Verde"]
["Cambodia"]
["Cameroon"]
["Canada"]
["Central African Republic (CAR)"]
["Chad"]
["Chile"]
["China"]
["Colombia"]
["Comoros"]
["Democratic Republic of the Congo"]
["Republic of the Congo"]
["Costa Rica"]
["Cote d'Ivoire"]
["Croatia"]
["Cuba"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Djibouti"]
["Dominica"]
["Dominican Republic"]
["Ecuador"]
["Egypt"]
["El Salvador"]
["Equatorial Guinea"]
["Eritrea"]
["Estonia"]
["Ethiopia"]
["Fiji"]
["Finland"]
["France"]
["Gabon"]
["Gambia"]
["Georgia"]
["Germany"]
["Ghana"]
["Greece"]
["Grenada"]
["Guatemala"]
["Guinea"]
["Guinea-Bissau"]
["Guyana"]
["Haiti"]
["Honduras"]
["Hungary"]
["Iceland"]
["India"]
["Indonesia"]
["Iran"]
["Iraq"]
["Ireland"]
["Israel"]
["Italy"]
["Jamaica"]
["Japan"]
["Jordan"]
["Kazakhstan"]
["Kenya"]
["Kiribati"]
["Kosovo"]
["Kuwait"]
["Kyrgyzstan"]
["Laos"]
["Latvia"]
["Lebanon"]
["Lesotho"]
["Liberia"]
["Libya"]
["Liechtenstein"]
["Lithuania"]
["Luxembourg"]
["Macedonia (FYROM)"]
["Madagascar"]
["Malawi"]
["Malaysia"]
["Maldives"]
["Mali"]
["Malta"]
["Marshall Islands"]
["Mauritania"]
["Mauritius"]
["Mexico"]
["Micronesia"]
["Moldova"]
["Monaco"]
["Mongolia"]
["Montenegro"]
["Morocco"]
["Mozambique"]
["Myanmar (Burma)"]
["Namibia"]
["Nauru"]
["Nepal"]
["Netherlands"]
["New Zealand"]
["Nicaragua"]
["Niger"]
["Nigeria"]
["North Korea"]
["Norway"]
["Oman"]
["Pakistan"]
["Palau"]
["Palestine"]
["Panama"]
["Papua New Guinea"]
["Paraguay"]
["Peru"]
["Philippines"]
["Poland"]
["Portugal"]
["Qatar"]
["Romania"]
["Russia"]
["Rwanda"]
["Saint Kitts and Nevis"]
["Saint Lucia"]
["Saint Vincent and the Grenadines"]
["Samoa"]
["San Marino"]
["Sao Tome and Principe"]
["Saudi Arabia"]
["Senegal"]
["Serbia"]
["Seychelles"]
["Sierra Leone"]
["Singapore"]
["Slovakia"]
["Slovenia"]
["Solomon Islands"]
["Somalia"]
["South Africa"]
["South Korea"]
["South Sudan"]
["Spain"]
["Sri Lanka"]
["Sudan"]
["Suriname"]
["Swaziland"]
["Sweden"]
["Switzerland"]
["Syria"]
["Taiwan"]
["Tajikistan"]
["Tanzania"]
["Thailand"]
["Timor-Leste"]
["Togo"]
["Tonga"]
["Trinidad and Tobago"]
["Tunisia"]
["Turkey"]
["Turkmenistan"]
["Tuvalu"]
["Uganda"]
["Ukraine"]
["United Arab Emirates (UAE)"]
["United Kingdom (UK)"]
["United States of America (USA)"]
["Uruguay"]
["Uzbekistan"]
["Vanuatu"]
["Vatican City (Holy See)"]
["Venezuela"]
["Vietnam"]
["Yemen"]
["Zambia"]
["Zimbabwe"]

{"sheet":"Results Check","index":4,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Question","Model Answer","User's Answer","Details of Check","TRUE/FALSE","0/1","Available Marks"]
[null,1,4,0,"Right or wrong",{"$f":"IFERROR(C3=D3,FALSE)","v":false},{"$f":"IF(F3=FALSE,0,1)","v":0},1]
[null,2,{"$f":"Assessment!L22/Assessment!L23","v":100},{"$f":"Assessment!L24","v":0},"Right or wrong",false,0,1]
[null,null,null,null,"ISFORMULA",{"$f":"_xlfn.ISFORMULA(Assessment!L24)","v":false},0,1]
[null,3,{"$f":"SUM(Assessment!L34:L38)","v":7.37},{"$f":"Assessment!L39","v":0},"Right or wrong",{"$f":"IFERROR(C6=D6,FALSE)","v":false},0,1]
[null,null,null,null,"ISFORMULA",{"$f":"_xlfn.ISFORMULA(Assessment!L39)","v":false},0,1]
[null,4]
[null,5,{"$f":"Assessment!L34*(1-Assessment!$P$34)","v":1.161},{"$f":"Assessment!M34","v":0},"1st formula right",{"$f":"IFERROR(C9=D9,FALSE)","v":false},0,1]
[null,null,{"$f":"Assessment!L35*(1-Assessment!$P$34)","v":1.341},{"$f":"Assessment!M35","v":0},"copied down",{"$f":"IFERROR(C10=D10,FALSE)","v":false},{"$f":"IF(COUNTIF($F$10:$F$13,\"false\")=0,1,0)","v":0},1]
[null,null,{"$f":"Assessment!L36*(1-Assessment!$P$34)","v":0.71100000000000008},{"$f":"Assessment!M36","v":0},"copied down",false]
[null,null,{"$f":"Assessment!L37*(1-Assessment!$P$34)","v":2.3400000000000003},{"$f":"Assessment!M37","v":0},"copied down",false]
[null,null,{"$f":"Assessment!L38*(1-Assessment!$P$34)","v":1.08},{"$f":"Assessment!M38","v":0},"copied down",false]
[null,null,{"$f":"SUM(C9:C13)","v":6.6330000000000009},{"$f":"Assessment!M39","v":0},"sum function",false,{"$f":"IF(F14=FALSE,0,1)","v":0},1]
[null,6]
[null,7,1500,{"$f":"Assessment!O48","v":2100},"Surnames Sorted correctly",false,{"$f":"IF(COUNTIF($F$16:$F$20,\"false\")=0,1,0)","v":0},1]
[null,null,2100,{"$f":"Assessment!O49","v":1750},null,false]
[null,null,1400,{"$f":"Assessment!O50","v":1400},null,true]
[null,null,1250,{"$f":"Assessment!O51","v":1250},null,true]
[null,null,1750,{"$f":"Assessment!O52","v":1500},null,false]
[null,8]
[null,9]
[null,10,null,null,"ISFORMULA",{"$f":"_xlfn.ISFORMULA(Assessment!O55)","v":false},{"$f":"IF(F23=FALSE,0,1)","v":0},1]
[null,10,1400,{"$f":"Assessment!O55","v":0},"Formula is correct",{"$f":"IFERROR(C24=D24,FALSE)","v":false},{"$f":"IF(F24=FALSE,0,1)","v":0},1]
[null,null,null,null,null,null,{"$f":"SUM(G3:G24)","v":0},{"$f":"SUM(H3:H24)","v":11}]
[null,null,null,null,null,null,null,{"$f":"G25/H25","v":0},"Percentage Achieved"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Model"]
[null,null,null,null,null,null,null,null,null,null,"Questions 7 to 10"]
[]
[null,null,null,null,null,null,null,null,null,null,"Surname","Initials","Gender","Date Started","Salary"]
[null,null,null,null,null,null,null,null,null,null,"Adams","L","Male","2013-11-01",15000]
[null,null,null,null,null,null,null,null,null,null,"Josephs","S","Female","2009-06-15",21000]
[null,null,null,null,null,null,null,null,null,null,"Mashaba","M","Male","2009-03-01",14000]
[null,null,null,null,null,null,null,null,null,null,"Naidoo","B","Male","2014-01-01",12500]
[null,null,null,null,null,null,null,null,null,null,"Naidoo","P","Female","2012-09-01",17500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mr Mashaba's salary:"]

{"sheet":"Import","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Values To Import Into Assessment Report"]
["First Name",{"$f":"First_Name","v":0}]
["Surname",{"$f":"Surname","v":0}]
["Email Address",{"$f":"Email_Address","v":0}]
["Company / Organisation",{"$f":"Organization","v":0}]
["Job Title / Position",{"$f":"Job_Title","v":0}]
["Contact No.",{"$f":"Cell_Number","v":0}]
["Percentage Achieved",{"$f":"Percentage_achieved","v":0}]
["Rating",{"$f":"Your_Rating","v":"Excel Virgin"}]
["Recommendation for 1st Workshop",{"$f":"Workshop_Recommendation","v":"Excel 101"}]